<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.DriverManager" %><%--
  Created by IntelliJ IDEA.
  User: 了
  Date: 2020/10/16
  Time: 11:25
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<%
    Class.forName("com.mysql.jdbc.Driver");
    String url ="jdbc:mysql://localhost:3306/mxy";
   Connection connection = DriverManager.getConnection(url,"root","root");

    String sql ="select * from user where username =? and password = ?";
    //PreparedStatement ps =connection.prepareStatement(sql);
    //ps.setString(1,request.getParameter("username"));
    // ps.setString(2,request.getParameter("password"));
    //ResultSet rs =ps.executeQuery();
    //while (rs.next()){
    //  out.print(rs.getString("username")+"-"+rs.getString(3)+"<br>");
    // }
    if(session.getAttribute("username")==null){
        out.print("登录失败,将3秒之后跳转到登录页面");
        response.setHeader("refresh","3;url='login.jsp'");
    }
    out.print("欢迎来到个人主页");
%>
</body>
</html>
